SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures 
									
				 WHERE  kategorija = 'Čelade Airoh' AND pod_kategorija = 'Kros' AND stil = 'Polikarbonat'
					ORDER BY cena LIMIT 18,9                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/6983/airoh-twist-20-tech-blue-gloss" class="link"></a>
							<h1>Airoh Twist 2.0 TECH BLUE GLOSS</h1>
							<div class="price">
							   								<span class="new">229,99 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 TECH BLUE GLOSS">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 TECH BLUE GLOSS" data-productid="6983-10e430c8351e470267987d2a9f0e16fc"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/7022/airoh-twist-20-lazyboy-gloss" class="link"></a>
							<h1>Airoh Twist 2.0 LAZYBOY GLOSS</h1>
							<div class="price">
							   								<span class="new">229,99 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 LAZYBOY GLOSS">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 LAZYBOY GLOSS" data-productid="7022-7ae04d69c89d13933eaf51fb6ad4bcfb"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/7023/airoh-twist-20-hell-matt" class="link"></a>
							<h1>Airoh Twist 2.0 HELL MATT</h1>
							<div class="price">
							   								<span class="new">229,99 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 HELL MATT">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 HELL MATT" data-productid="7023-01247953e51acadbe40c01eab03bd029"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/5516/airoh-twist-20-replica-cairoli" class="link"></a>
							<h1>Airoh Twist 2.0 Replica Cairoli</h1>
							<div class="price">
							   								<span class="new">230,10 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 Replica Cairoli">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 Replica Cairoli" data-productid="5516-0e4340245c832965c37bd4f43fb6ae6b"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/5518/airoh-twist-20-rockstar" class="link"></a>
							<h1>Airoh Twist 2.0 Rockstar</h1>
							<div class="price">
							   								<span class="new">230,10 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 Rockstar">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 Rockstar" data-productid="5518-a66a636f5e41d2d805a8fd597aeb088d"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/5519/airoh-twist-20-racr" class="link"></a>
							<h1>Airoh Twist 2.0 RACR</h1>
							<div class="price">
							   								<span class="new">230,10 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 RACR">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 RACR" data-productid="5519-6a2a50bed9c9711e3544d7b1b79bf6d3"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/6987/airoh-twist-20-lift-red-matt" class="link"></a>
							<h1>Airoh Twist 2.0 LIFT RED MATT</h1>
							<div class="price">
							   								<span class="new">249,99 €</span>
							</div>
							<div class="img-wr">
								<img src="https://aures.si/wp-content/uploads/2022/01/TW2BI31-2.jpg" alt="Airoh Twist 2.0 LIFT RED MATT">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 LIFT RED MATT" data-productid="6987-b9b6ade684bca371db051370d5d61c55"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/7013/airoh-twist-20-lift-white-blue-gloss" class="link"></a>
							<h1>Airoh Twist 2.0 LIFT WHITE/BLUE GLOSS</h1>
							<div class="price">
							   								<span class="new">249,99 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 LIFT WHITE/BLUE GLOSS">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 LIFT WHITE/BLUE GLOSS" data-productid="7013-cb642285192d6497fe7c17c27c280cd7"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
                        
              <li class="infinite-item"><a href="/moto-oprema/produkt/7018/airoh-twist-20-lift-yellow-matt" class="link"></a>
							<h1>Airoh Twist 2.0 LIFT YELLOW MATT</h1>
							<div class="price">
							   								<span class="new">249,99 €</span>
							</div>
							<div class="img-wr">
								<img src="/gfx/_box-images/ni_slike.jpg" alt="Airoh Twist 2.0 LIFT YELLOW MATT">
							</div>
							<div class="actions">
								<i class="flaticon-magnifying47"></i> 
								<a href="#" data-producttype="4" data-productname="Airoh Twist 2.0 LIFT YELLOW MATT" data-productid="7018-fa3fca9102dcb05af7c73ab0974e5f1e"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
							</div>
						</li>
	<a class="infinite-more-link" href="/_ajax/ajax.load-aures-produkti.php?page=3&filter= kategorija = 'Čelade Airoh' AND pod_kategorija = 'Kros' AND stil = 'Polikarbonat'"></a>